create or replace procedure sp_keyword_add
(
       p_keyw varchar2
)
as
v_keyw_count int;
begin
      select count(*) into v_keyw_count from tb_search_keyword where keyword= p_keyw;
      if(v_keyw_count = 0) then
          insert into tb_search_keyword(keyword, keyw_cnt) values(p_keyw, 1);
      else
          update tb_search_keyword set keyw_cnt = keyw_cnt +1, upd_time = sysdate where keyword = p_keyw;
      end if;
end;